{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Method Comparison","Alt Method Comparison"],"not_rendered":{"charts":5,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Method Comparison","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,11],[4,1,4,3],[5,1,5,3],[9,0,9,4],[37,0,37,1],[32,5,33,13],[34,0,34,1],[35,0,35,1],[36,0,36,1]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 504 (version 1.0). Accuracy (WBC)_Example. Page 1 of 2"]
[null," Quantitative Method Comparison"]
[]
[null,"Method being evaluated (Y):",null,null,"Cell Dyn Ruby",{"$nulls":4},"Date:","2023-07-19"]
[null,"Reference Method (X): ",null,null,"Cell Dyn 3500",{"$nulls":4},"Total Allowable Error (TEa):"]
[null,null,null,"Analyte:","WBC",{"$nulls":4},"Conc.","Pct."]
[null,null,null,"Units:","10E3/uL",{"$nulls":4},0.12,15]
[]
[{"$f":"IF(AND($C$37>0.975,$H$32>=19),\"Experiment: PASSED\",\"Experiment: FAILED (See Note Below**)\")","v":"Experiment: PASSED"}]
["Spec#","X","Y","Δ","Error Index","High lmt","Low lmt","Grade"]
[1,3.0299999999999998,3,{"$f":"C12-B12","v":-0.029999999999999805},{"$f":"IF($J$8>B12*($K$8/100),D12/$J$8,D12/(B12*($K$8/100)))","v":-0.066006600660065584},{"$f":"IF(B12+$J$8>B12*((100+$K$8)/100),B12+$J$8,B12*((100+$K$8)/100))","v":3.4844999999999997},{"$f":"IF(B12-$J$8<B12*((100-$K$8)/100),B12-$J$8,B12*((100-$K$8)/100))","v":2.5754999999999999},{"$f":"IF(AND(E12>=-1,E12<=1),1,0)","v":1}]
[{"$f":"A12+1","v":2},7.6600000000000001,7.7800000000000002,{"$f":"C13-B13","v":0.12000000000000011},{"$f":"IF($J$8>B13*($K$8/100),D13/$J$8,D13/(B13*($K$8/100)))","v":0.10443864229765022},{"$f":"IF(B13+$J$8>B13*((100+$K$8)/100),B13+$J$8,B13*((100+$K$8)/100))","v":8.8089999999999993},{"$f":"IF(B13-$J$8<B13*((100-$K$8)/100),B13-$J$8,B13*((100-$K$8)/100))","v":6.5110000000000001},{"$f":"IF(AND(E13>=-1,E13<=1),1,0)","v":1}]
[{"$f":"A13+1","v":3},20.23,20.800000000000001,{"$f":"C14-B14","v":0.57000000000000028},{"$f":"IF($J$8>B14*($K$8/100),D14/$J$8,D14/(B14*($K$8/100)))","v":0.18783984181908067},{"$f":"IF(B14+$J$8>B14*((100+$K$8)/100),B14+$J$8,B14*((100+$K$8)/100))","v":23.264499999999998},{"$f":"IF(B14-$J$8<B14*((100-$K$8)/100),B14-$J$8,B14*((100-$K$8)/100))","v":17.195499999999999},{"$f":"IF(AND(E14>=-1,E14<=1),1,0)","v":1}]
[{"$f":"A14+1","v":4},3.1800000000000002,3.02,{"$f":"C15-B15","v":-0.16000000000000014},{"$f":"IF($J$8>B15*($K$8/100),D15/$J$8,D15/(B15*($K$8/100)))","v":-0.33542976939203384},{"$f":"IF(B15+$J$8>B15*((100+$K$8)/100),B15+$J$8,B15*((100+$K$8)/100))","v":3.657},{"$f":"IF(B15-$J$8<B15*((100-$K$8)/100),B15-$J$8,B15*((100-$K$8)/100))","v":2.7029999999999998},{"$f":"IF(AND(E15>=-1,E15<=1),1,0)","v":1}]
[{"$f":"A15+1","v":5},20.010000000000002,20.699999999999999,{"$f":"C16-B16","v":0.68999999999999773},{"$f":"IF($J$8>B16*($K$8/100),D16/$J$8,D16/(B16*($K$8/100)))","v":0.22988505747126362},{"$f":"IF(B16+$J$8>B16*((100+$K$8)/100),B16+$J$8,B16*((100+$K$8)/100))","v":23.011500000000002},{"$f":"IF(B16-$J$8<B16*((100-$K$8)/100),B16-$J$8,B16*((100-$K$8)/100))","v":17.008500000000002},{"$f":"IF(AND(E16>=-1,E16<=1),1,0)","v":1}]
[{"$f":"A16+1","v":6},3.4100000000000001,2.8799999999999999,{"$f":"C17-B17","v":-0.53000000000000025},{"$f":"IF($J$8>B17*($K$8/100),D17/$J$8,D17/(B17*($K$8/100)))","v":-1.0361681329423271},{"$f":"IF(B17+$J$8>B17*((100+$K$8)/100),B17+$J$8,B17*((100+$K$8)/100))","v":3.9215},{"$f":"IF(B17-$J$8<B17*((100-$K$8)/100),B17-$J$8,B17*((100-$K$8)/100))","v":2.8984999999999999},{"$f":"IF(AND(E17>=-1,E17<=1),1,0)","v":0}]
[{"$f":"A17+1","v":7},8.3499999999999996,7.9900000000000002,{"$f":"C18-B18","v":-0.35999999999999943},{"$f":"IF($J$8>B18*($K$8/100),D18/$J$8,D18/(B18*($K$8/100)))","v":-0.28742514970059835},{"$f":"IF(B18+$J$8>B18*((100+$K$8)/100),B18+$J$8,B18*((100+$K$8)/100))","v":9.6024999999999991},{"$f":"IF(B18-$J$8<B18*((100-$K$8)/100),B18-$J$8,B18*((100-$K$8)/100))","v":7.0974999999999993},{"$f":"IF(AND(E18>=-1,E18<=1),1,0)","v":1}]
[{"$f":"A18+1","v":8},3.3500000000000001,3.23,{"$f":"C19-B19","v":-0.12000000000000011},{"$f":"IF($J$8>B19*($K$8/100),D19/$J$8,D19/(B19*($K$8/100)))","v":-0.23880597014925398},{"$f":"IF(B19+$J$8>B19*((100+$K$8)/100),B19+$J$8,B19*((100+$K$8)/100))","v":3.8524999999999996},{"$f":"IF(B19-$J$8<B19*((100-$K$8)/100),B19-$J$8,B19*((100-$K$8)/100))","v":2.8475000000000001},{"$f":"IF(AND(E19>=-1,E19<=1),1,0)","v":1}]
[{"$f":"A19+1","v":9},21.16,21.100000000000001,{"$f":"C20-B20","v":-0.059999999999998721},{"$f":"IF($J$8>B20*($K$8/100),D20/$J$8,D20/(B20*($K$8/100)))","v":-0.018903591682419257},{"$f":"IF(B20+$J$8>B20*((100+$K$8)/100),B20+$J$8,B20*((100+$K$8)/100))","v":24.334},{"$f":"IF(B20-$J$8<B20*((100-$K$8)/100),B20-$J$8,B20*((100-$K$8)/100))","v":17.986000000000001},{"$f":"IF(AND(E20>=-1,E20<=1),1,0)","v":1}]
[{"$f":"A20+1","v":10},21.23,21,{"$f":"C21-B21","v":-0.23000000000000043},{"$f":"IF($J$8>B21*($K$8/100),D21/$J$8,D21/(B21*($K$8/100)))","v":-0.072224839064217436},{"$f":"IF(B21+$J$8>B21*((100+$K$8)/100),B21+$J$8,B21*((100+$K$8)/100))","v":24.4145},{"$f":"IF(B21-$J$8<B21*((100-$K$8)/100),B21-$J$8,B21*((100-$K$8)/100))","v":18.045500000000001},{"$f":"IF(AND(E21>=-1,E21<=1),1,0)","v":1}]
[{"$f":"A21+1","v":11},2.5,2.7000000000000002,{"$f":"C22-B22","v":0.20000000000000018},{"$f":"IF($J$8>B22*($K$8/100),D22/$J$8,D22/(B22*($K$8/100)))","v":0.53333333333333377},{"$f":"IF(B22+$J$8>B22*((100+$K$8)/100),B22+$J$8,B22*((100+$K$8)/100))","v":2.875},{"$f":"IF(B22-$J$8<B22*((100-$K$8)/100),B22-$J$8,B22*((100-$K$8)/100))","v":2.125},{"$f":"IF(AND(E22>=-1,E22<=1),1,0)","v":1}]
[{"$f":"A22+1","v":12},10.4,10.6,{"$f":"C23-B23","v":0.19999999999999929},{"$f":"IF($J$8>B23*($K$8/100),D23/$J$8,D23/(B23*($K$8/100)))","v":0.12820512820512775},{"$f":"IF(B23+$J$8>B23*((100+$K$8)/100),B23+$J$8,B23*((100+$K$8)/100))","v":11.959999999999999},{"$f":"IF(B23-$J$8<B23*((100-$K$8)/100),B23-$J$8,B23*((100-$K$8)/100))","v":8.8399999999999999},{"$f":"IF(AND(E23>=-1,E23<=1),1,0)","v":1}]
[{"$f":"A23+1","v":13},15.800000000000001,16.300000000000001,{"$f":"C24-B24","v":0.5},{"$f":"IF($J$8>B24*($K$8/100),D24/$J$8,D24/(B24*($K$8/100)))","v":0.21097046413502107},{"$f":"IF(B24+$J$8>B24*((100+$K$8)/100),B24+$J$8,B24*((100+$K$8)/100))","v":18.169999999999998},{"$f":"IF(B24-$J$8<B24*((100-$K$8)/100),B24-$J$8,B24*((100-$K$8)/100))","v":13.43},{"$f":"IF(AND(E24>=-1,E24<=1),1,0)","v":1}]
[{"$f":"A24+1","v":14},18.5,19,{"$f":"C25-B25","v":0.5},{"$f":"IF($J$8>B25*($K$8/100),D25/$J$8,D25/(B25*($K$8/100)))","v":0.1801801801801802},{"$f":"IF(B25+$J$8>B25*((100+$K$8)/100),B25+$J$8,B25*((100+$K$8)/100))","v":21.274999999999999},{"$f":"IF(B25-$J$8<B25*((100-$K$8)/100),B25-$J$8,B25*((100-$K$8)/100))","v":15.725},{"$f":"IF(AND(E25>=-1,E25<=1),1,0)","v":1}]
[{"$f":"A25+1","v":15},12.6,13,{"$f":"C26-B26","v":0.40000000000000036},{"$f":"IF($J$8>B26*($K$8/100),D26/$J$8,D26/(B26*($K$8/100)))","v":0.21164021164021185},{"$f":"IF(B26+$J$8>B26*((100+$K$8)/100),B26+$J$8,B26*((100+$K$8)/100))","v":14.489999999999998},{"$f":"IF(B26-$J$8<B26*((100-$K$8)/100),B26-$J$8,B26*((100-$K$8)/100))","v":10.709999999999999},{"$f":"IF(AND(E26>=-1,E26<=1),1,0)","v":1}]
[{"$f":"A26+1","v":16},8.1999999999999993,7.7999999999999998,{"$f":"C27-B27","v":-0.39999999999999947},{"$f":"IF($J$8>B27*($K$8/100),D27/$J$8,D27/(B27*($K$8/100)))","v":-0.32520325203251993},{"$f":"IF(B27+$J$8>B27*((100+$K$8)/100),B27+$J$8,B27*((100+$K$8)/100))","v":9.4299999999999979},{"$f":"IF(B27-$J$8<B27*((100-$K$8)/100),B27-$J$8,B27*((100-$K$8)/100))","v":6.9699999999999989},{"$f":"IF(AND(E27>=-1,E27<=1),1,0)","v":1}]
[{"$f":"A27+1","v":17},6.9000000000000004,6.4000000000000004,{"$f":"C28-B28","v":-0.5},{"$f":"IF($J$8>B28*($K$8/100),D28/$J$8,D28/(B28*($K$8/100)))","v":-0.48309178743961356},{"$f":"IF(B28+$J$8>B28*((100+$K$8)/100),B28+$J$8,B28*((100+$K$8)/100))","v":7.9349999999999996},{"$f":"IF(B28-$J$8<B28*((100-$K$8)/100),B28-$J$8,B28*((100-$K$8)/100))","v":5.8650000000000002},{"$f":"IF(AND(E28>=-1,E28<=1),1,0)","v":1}]
[{"$f":"A28+1","v":18},5.0999999999999996,5.2000000000000002,{"$f":"C29-B29","v":0.10000000000000053},{"$f":"IF($J$8>B29*($K$8/100),D29/$J$8,D29/(B29*($K$8/100)))","v":0.13071895424836671},{"$f":"IF(B29+$J$8>B29*((100+$K$8)/100),B29+$J$8,B29*((100+$K$8)/100))","v":5.8649999999999993},{"$f":"IF(B29-$J$8<B29*((100-$K$8)/100),B29-$J$8,B29*((100-$K$8)/100))","v":4.335},{"$f":"IF(AND(E29>=-1,E29<=1),1,0)","v":1}]
[{"$f":"A29+1","v":19},4.5999999999999996,4.7999999999999998,{"$f":"C30-B30","v":0.20000000000000018},{"$f":"IF($J$8>B30*($K$8/100),D30/$J$8,D30/(B30*($K$8/100)))","v":0.2898550724637684},{"$f":"IF(B30+$J$8>B30*((100+$K$8)/100),B30+$J$8,B30*((100+$K$8)/100))","v":5.2899999999999991},{"$f":"IF(B30-$J$8<B30*((100-$K$8)/100),B30-$J$8,B30*((100-$K$8)/100))","v":3.9099999999999997},{"$f":"IF(AND(E30>=-1,E30<=1),1,0)","v":1}]
[{"$f":"A30+1","v":20},19.5,20,{"$f":"C31-B31","v":0.5},{"$f":"IF($J$8>B31*($K$8/100),D31/$J$8,D31/(B31*($K$8/100)))","v":0.17094017094017094},{"$f":"IF(B31+$J$8>B31*((100+$K$8)/100),B31+$J$8,B31*((100+$K$8)/100))","v":22.424999999999997},{"$f":"IF(B31-$J$8<B31*((100-$K$8)/100),B31-$J$8,B31*((100-$K$8)/100))","v":16.574999999999999},{"$f":"IF(AND(E31>=-1,E31<=1),1,0)","v":1}]
["Mean",{"$f":"AVERAGE(B12:B31)","v":10.785499999999999},{"$f":"AVERAGE(C12:C31)","v":10.865},{"$f":"AVERAGE(D12:D31)","v":0.079500000000000015},{"$f":"AVERAGE(E12:E31)","v":-0.024262601816443692},null,null,{"$f":"SUM(H12:H31)","v":19}]
["Min",{"$f":"MIN(B12:B31)","v":2.5},{"$f":"MIN(C12:C31)","v":2.7000000000000002},{"$f":"MIN(D12:D31)","v":-0.53000000000000025},{"$f":"MIN(E12:E31)","v":-1.0361681329423271},{"$f":"IF($H$32<19,\"**Greater than 5% of the error indices are unacceptable. IF the correlation coeficient is greater than 0.975 (see below-left), see Alt Method Comparison tab for evaluation.\",\"\")","v":""}]
["Max",{"$f":"MAX(B12:B31)","v":21.23},{"$f":"MAX(C12:C31)","v":21.100000000000001},{"$f":"MAX(D12:D31)","v":0.68999999999999773},{"$f":"MAX(E12:E31)","v":0.53333333333333377}]
["Slope",null,{"$f":"SLOPE(C12:C31,B12:B31)","v":1.0274750526032912}]
["Intercept",null,{"$f":"INTERCEPT(C12:C31,B12:B31)","v":-0.2168321798527959}]
["Correl. Coef. (R)",null,{"$f":"CORREL(B12:B31,C12:C31)","v":0.99905226586687557},{"$f":"IF(C37<0.975,\"**Correlation Coefficient is too low. Troubleshoot Assay and re-analyse specimens\",\"\")","v":""}]

{"sheet":"Alt Method Comparison","index":1,"n_rows":59,"n_cols":18,"rows_kept":59,"cut":false,"hidden":false,"merged":[[5,15,5,16],[44,7,44,8],[2,6,3,14],[25,12,25,14],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[35,8,35,11],[5,6,5,8],[6,7,6,8],[7,9,7,13],[6,9,6,13],[5,9,5,13]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 10-Aug-2023. Last reviewed on 10-Aug-2023.\r\nRDP 504 (version 1.0). Accuracy (WBC)_Example. Page 2 of 2"]
[{"$nulls":6},"Alternate (Quantitative) Method Comparison",{"$nulls":10},{"$f":"(D12/B12)*100","v":-0.99009900990098365}]
[{"$nulls":17},{"$f":"(D13/B13)*100","v":1.5665796344647531}]
[{"$nulls":17},{"$f":"(D14/B14)*100","v":2.8175976272862098}]
[{"$nulls":6},"Method being evaluated:",null,null,{"$f":"'Method Comparison'!E5","v":"Cell Dyn Ruby"},{"$nulls":4},"Date:",{"$f":"'Method Comparison'!K5","v":45126},null,{"$f":"(D15/B15)*100","v":-5.0314465408805074}]
[{"$nulls":7},"Reference Method: ",null,{"$f":"'Method Comparison'!E6","v":"Cell Dyn 3500"},{"$nulls":4},"Total Allowable Error (TEa):",null,null,{"$f":"(D16/B16)*100","v":3.4482758620689538}]
[{"$nulls":8},"Analyte:",{"$f":"'Method Comparison'!E7","v":"WBC"},{"$nulls":4},"Conc.","Pct.",null,{"$f":"(D17/B17)*100","v":-15.542521994134903}]
[{"$nulls":8},"Units:",{"$f":"IF('Method Comparison'!E8>0,'Method Comparison'!E8,\"Units not entered\")","v":"10E3/uL"},{"$nulls":4},{"$f":"'Method Comparison'!J8","v":0.12},{"$f":"'Method Comparison'!K8","v":15},null,{"$f":"(D18/B18)*100","v":-4.3113772455089752}]
[{"$nulls":17},{"$f":"(D19/B19)*100","v":-3.5820895522388088}]
["Spec#","X","Y","∆","((Y-X)-Bias)^2",{"$nulls":12},{"$f":"(D20/B20)*100","v":-0.28355387523628883}]
[1,{"$f":"'Method Comparison'!B12","v":3.0299999999999998},{"$f":"'Method Comparison'!C12","v":3},{"$f":"C12-B12","v":-0.029999999999999805},{"$f":"POWER(D12-$D$35,2)","v":0.011990250000000228},{"$f":"E12/19","v":0.00063106578947369626},{"$nulls":11},{"$f":"(D21/B21)*100","v":-1.0833725859632615}]
[{"$f":"A12+1","v":2},{"$f":"'Method Comparison'!B13","v":7.6600000000000001},{"$f":"'Method Comparison'!C13","v":7.7800000000000002},{"$f":"C13-B13","v":0.12000000000000011},{"$f":"POWER(D13-$D$35,2)","v":0.0016402499999999085},{"$f":"E13/19","v":8.6328947368416236E-05},{"$nulls":11},{"$f":"(D22/B22)*100","v":8.0000000000000071}]
[{"$f":"A13+1","v":3},{"$f":"'Method Comparison'!B14","v":20.23},{"$f":"'Method Comparison'!C14","v":20.800000000000001},{"$f":"C14-B14","v":0.57000000000000028},{"$f":"POWER(D14-$D$35,2)","v":0.24059024999999906},{"$f":"E14/19","v":0.012662644736842055},{"$nulls":11},{"$f":"(D23/B23)*100","v":1.9230769230769162}]
[{"$f":"A14+1","v":4},{"$f":"'Method Comparison'!B15","v":3.1800000000000002},{"$f":"'Method Comparison'!C15","v":3.02},{"$f":"C15-B15","v":-0.16000000000000014},{"$f":"POWER(D15-$D$35,2)","v":0.057360250000000661},{"$f":"E15/19","v":0.003018960526315824},{"$nulls":11},{"$f":"(D24/B24)*100","v":3.164556962025316}]
[{"$f":"A15+1","v":5},{"$f":"'Method Comparison'!B16","v":20.010000000000002},{"$f":"'Method Comparison'!C16","v":20.699999999999999},{"$f":"C16-B16","v":0.68999999999999773},{"$f":"POWER(D16-$D$35,2)","v":0.37271024999999569},{"$f":"E16/19","v":0.019616328947368193},null,0,{"$f":"J38","v":-0.2168321798527959},{"$nulls":8},{"$f":"(D25/B25)*100","v":2.7027027027027026}]
[{"$f":"A16+1","v":6},{"$f":"'Method Comparison'!B17","v":3.4100000000000001},{"$f":"'Method Comparison'!C17","v":2.8799999999999999},{"$f":"C17-B17","v":-0.53000000000000025},{"$f":"POWER(D17-$D$35,2)","v":0.3714902500000018},{"$f":"E17/19","v":0.019552118421052728},null,{"$f":"B12","v":3.0299999999999998},{"$f":"C12","v":3},{"$nulls":8},{"$f":"(D26/B26)*100","v":3.1746031746031771}]
[{"$f":"A17+1","v":7},{"$f":"'Method Comparison'!B18","v":8.3499999999999996},{"$f":"'Method Comparison'!C18","v":7.9900000000000002},{"$f":"C18-B18","v":-0.35999999999999943},{"$f":"POWER(D18-$D$35,2)","v":0.19316025000000059},{"$f":"E18/19","v":0.010166328947368452},{"$nulls":11},{"$f":"(D27/B27)*100","v":-4.8780487804877986}]
[{"$f":"A18+1","v":8},{"$f":"'Method Comparison'!B19","v":3.3500000000000001},{"$f":"'Method Comparison'!C19","v":3.23},{"$f":"C19-B19","v":-0.12000000000000011},{"$f":"POWER(D19-$D$35,2)","v":0.039800250000000537},{"$f":"E19/19","v":0.0020947500000000284},{"$nulls":11},{"$f":"(D28/B28)*100","v":-7.2463768115942031}]
[{"$f":"A19+1","v":9},{"$f":"'Method Comparison'!B20","v":21.16},{"$f":"'Method Comparison'!C20","v":21.100000000000001},{"$f":"C20-B20","v":-0.059999999999998721},{"$f":"POWER(D20-$D$35,2)","v":0.019460249999999988},{"$f":"E20/19","v":0.0010242236842105256},{"$nulls":11},{"$f":"(D29/B29)*100","v":1.960784313725501}]
[{"$f":"A20+1","v":10},{"$f":"'Method Comparison'!B21","v":21.23},{"$f":"'Method Comparison'!C21","v":21},{"$f":"C21-B21","v":-0.23000000000000043},{"$f":"POWER(D21-$D$35,2)","v":0.095790250000001034},{"$f":"E21/19","v":0.0050415921052632123},{"$nulls":11},{"$f":"(D30/B30)*100","v":4.3478260869565259}]
[{"$f":"A21+1","v":11},{"$f":"'Method Comparison'!B22","v":2.5},{"$f":"'Method Comparison'!C22","v":2.7000000000000002},{"$f":"C22-B22","v":0.20000000000000018},{"$f":"POWER(D22-$D$35,2)","v":0.014520249999999745},{"$f":"E22/19","v":0.00076422368421051286},{"$nulls":11},{"$f":"(D31/B31)*100","v":2.5641025641025639}]
[{"$f":"A22+1","v":12},{"$f":"'Method Comparison'!B23","v":10.4},{"$f":"'Method Comparison'!C23","v":10.6},{"$f":"C23-B23","v":0.19999999999999929},{"$f":"POWER(D23-$D$35,2)","v":0.01452024999999953},{"$f":"E23/19","v":0.00076422368421050159}]
[{"$f":"A23+1","v":13},{"$f":"'Method Comparison'!B24","v":15.800000000000001},{"$f":"'Method Comparison'!C24","v":16.300000000000001},{"$f":"C24-B24","v":0.5},{"$f":"POWER(D24-$D$35,2)","v":0.17682024999999896},{"$f":"E24/19","v":0.0093063289473683669}]
[{"$f":"A24+1","v":14},{"$f":"'Method Comparison'!B25","v":18.5},{"$f":"'Method Comparison'!C25","v":19},{"$f":"C25-B25","v":0.5},{"$f":"POWER(D25-$D$35,2)","v":0.17682024999999896},{"$f":"E25/19","v":0.0093063289473683669}]
[{"$f":"A25+1","v":15},{"$f":"'Method Comparison'!B26","v":12.6},{"$f":"'Method Comparison'!C26","v":13},{"$f":"C26-B26","v":0.40000000000000036},{"$f":"POWER(D26-$D$35,2)","v":0.10272024999999943},{"$f":"E26/19","v":0.0054063289473683914},null,"X Method",null,"Y Method ",null,null,"95% Conf. Limits",null,null,null,"Grade"]
[{"$f":"A26+1","v":16},{"$f":"'Method Comparison'!B27","v":8.1999999999999993},{"$f":"'Method Comparison'!C27","v":7.7999999999999998},{"$f":"C27-B27","v":-0.39999999999999947},{"$f":"POWER(D27-$D$35,2)","v":0.22992025000000069},{"$f":"E27/19","v":0.01210106578947372},null," MDP",null,"Pred. MDP",null,null,"Low",null,"High"]
[{"$f":"A27+1","v":17},{"$f":"'Method Comparison'!B28","v":6.9000000000000004},{"$f":"'Method Comparison'!C28","v":6.4000000000000004},{"$f":"C28-B28","v":-0.5},{"$f":"POWER(D28-$D$35,2)","v":0.33582025000000143},{"$f":"E28/19","v":0.017674750000000076},{"$f":"IF(($P$9/100)*H28>$O$9,($P$9/100)*H28,$O$9)","v":7.5},50,null,{"$f":"IF((H28*$J$37)+$J$38>0,(H28*$J$37)+$J$38,\"-\")","v":51.156920450311766},null,null,{"$f":"IF(H28>0,(H28*($J$37-$L$37))+($J$38-$L$38),\"-\")","v":50.494115506030454},null,{"$f":"IF(H28>0,(H28*($J$37+$L$37))+($J$38+$L$38),\"-\")","v":51.819725394593078},null,{"$f":"IF(AND(ABS(M28-H28)<G28,ABS(O28-H28)<G28),\"Acceptable\",\"Unacceptable\")","v":"Acceptable"}]
[{"$f":"A28+1","v":18},{"$f":"'Method Comparison'!B29","v":5.0999999999999996},{"$f":"'Method Comparison'!C29","v":5.2000000000000002},{"$f":"C29-B29","v":0.10000000000000053},{"$f":"POWER(D29-$D$35,2)","v":0.00042024999999997116},{"$f":"E29/19","v":2.2118421052630062E-05},{"$f":"IF(($P$9/100)*H29>$O$9,($P$9/100)*H29,$O$9)","v":10.5},70,null,{"$f":"IF((H29*J37)+J38>0,(H29*J37)+J38,\"-\")","v":71.70642150237758},null,null,{"$f":"IF(H29>0,(H29*($J$37-$L$37))+($J$38-$L$38),\"-\")","v":70.832592410097703},null,{"$f":"IF(H29>0,(H29*($J$37+$L$37))+($J$38+$L$38),\"-\")","v":72.580250594657485},null,{"$f":"IF(AND(ABS(M29-H29)<G29,ABS(O29-H29)<G29),\"Acceptable\",\"Unacceptable\")","v":"Acceptable"}]
[{"$f":"A29+1","v":19},{"$f":"'Method Comparison'!B30","v":4.5999999999999996},{"$f":"'Method Comparison'!C30","v":4.7999999999999998},{"$f":"C30-B30","v":0.20000000000000018},{"$f":"POWER(D30-$D$35,2)","v":0.014520249999999745},{"$f":"E30/19","v":0.00076422368421051286},{"$f":"IF(($P$9/100)*H30>$O$9,($P$9/100)*H30,$O$9)","v":16.5},110,null,{"$f":"IF((H30*J37)+J38>0,(H30*J37)+J38,\"-\")","v":112.80542360650924},null,null,{"$f":"IF(H30>0,(H30*($J$37-$L$37))+($J$38-$L$38),\"-\")","v":111.50954621823219},null,{"$f":"IF(H30>0,(H30*($J$37+$L$37))+($J$38+$L$38),\"-\")","v":114.10130099478629},null,{"$f":"IF(AND(ABS(M30-H30)<G30,ABS(O30-H30)<G30),\"Acceptable\",\"Unacceptable\")","v":"Acceptable"}]
[{"$f":"A30+1","v":20},{"$f":"'Method Comparison'!B31","v":19.5},{"$f":"'Method Comparison'!C31","v":20},{"$f":"C31-B31","v":0.5},{"$f":"POWER(D31-$D$35,2)","v":0.17682024999999896},{"$f":"E31/19","v":0.0093063289473683669},{"$f":"IF(($P$9/100)*H31>$O$9,($P$9/100)*H31,$O$9)","v":60},400,null,{"$f":"IF((H31*J37)+J38>0,(H31*J37)+J38,\"-\")","v":410.77318886146367},null,null,{"$f":"IF(H31>0,(H31*($J$37-$L$37))+($J$38-$L$38),\"-\")","v":406.41746132720721},null,{"$f":"IF(H31>0,(H31*($J$37+$L$37))+($J$38+$L$38),\"-\")","v":415.12891639572013},null,{"$f":"IF(AND(ABS(M31-H31)<G31,ABS(O31-H31)<G31),\"Acceptable\",\"Unacceptable\")","v":"Acceptable"}]
["Mean",{"$f":"AVERAGE(B12:B31)","v":10.785499999999999},{"$f":"AVERAGE(C12:C31)","v":10.865},{"$f":"AVERAGE(D12:D31)","v":0.079500000000000015},{"$f":"POWER(D32-$D$35,2)","v":1.4914401489334754E-30},{"$f":"SUM(F12:F31)","v":0.13931026315789458},{"$f":"IF(($P$9/100)*H32>$O$9,($P$9/100)*H32,$O$9)","v":150},1000,null,{"$f":"IF((H32*J37)+J38>0,(H32*J37)+J38,\"-\")","v":1027.2582204234384},null,null,{"$f":"IF(H32>0,(H32*($J$37-$L$37))+($J$38-$L$38),\"-\")","v":1016.5717684492246},null,{"$f":"IF(H32>0,(H32*($J$37+$L$37))+($J$38+$L$38),\"-\")","v":1037.9446723976523},null,{"$f":"IF(AND(ABS(M32-H32)<G32,ABS(O32-H32)<G32),\"Acceptable\",\"Unacceptable\")","v":"Acceptable"}]
["SD",{"$f":"STDEV(B11:B31)","v":7.1061252118377274},{"$f":"STDEV(C12:C31)","v":7.3082926942797739},{"$f":"STDEV(D12:D31)","v":0.37324290101473406},null,null,{"$f":"IF(($P$9/100)*H33>$O$9,($P$9/100)*H33,$O$9)","v":0.12}]
["Bias",null,null,{"$f":"C32-B32","v":0.079500000000001236},{"$f":"E32/19","v":7.8496849943867126E-32}]
[null,null,null,{"$f":"ABS(D34)","v":0.079500000000001236}]
[{"$nulls":8},"Regression Statistics"]
[{"$nulls":8},"Slope",{"$f":"SLOPE(C12:C31,B12:B31)","v":1.0274750526032912},"±",{"$f":"N38","v":0.010551207399928996},null,{"$f":"LINEST(C12:C31,B12:B31,TRUE,TRUE)","v":1.027475052603291},-0.21683217985279413]
[null,"Interc?",{"$f":"INDEX(LINEST(C12:C31,B12:B31,1,1),1,2)","v":-0.21683217985279413},{"$nulls":5},"Intercept",{"$f":"INTERCEPT(C12:C31,B12:B31)","v":-0.2168321798527959},"±",{"$f":"O38","v":0.13524457428486095},null,0.010551207399928996,0.13524457428486095]
[null,0,0,{"$nulls":5},"Std Err Est",{"$f":"STEYX(C12:C31,B12:B31)","v":0.32682240077860197},null,null,null,0.99810542993373796,0.32682240077861252]
[null,{"$f":"IF(B12*($P$9/100)>$O$9,B12+(B12*($P$9/100)),B12+$O$9)","v":3.4844999999999997},{"$f":"IF($B12*($P$9/100)>$O$9,$B12-($B12*($P$9/100)),$B12-$O$9)","v":2.5754999999999999},{"$nulls":5},"slope err",{"$f":"INDEX(LINEST(C12:C31,B12:B31,1,1),2,1)","v":0.010551207399928996},null,null,null,9482.8362691559978,18]
[null,{"$f":"IF(B13*($P$9/100)>$O$9,B13+(B13*($P$9/100)),B13+$O$9)","v":8.8090000000000011},{"$f":"IF($B13*($P$9/100)>$O$9,$B13-($B13*($P$9/100)),$B13-$O$9)","v":6.5110000000000001},{"$nulls":4},"Correl Coef (R):",null,{"$f":"CORREL(B12:B31,C12:C31)","v":0.99905226586687557},null,null,null,1012.8890681302875,1.9226318697125284]
[null,{"$f":"IF(B14*($P$9/100)>$O$9,B14+(B14*($P$9/100)),B14+$O$9)","v":23.264500000000002},{"$f":"IF($B14*($P$9/100)>$O$9,$B14-($B14*($P$9/100)),$B14-$O$9)","v":17.195499999999999},{"$nulls":4},"Bias:",null,{"$f":"D34","v":0.079500000000001236}]
[null,{"$f":"IF(B15*($P$9/100)>$O$9,B15+(B15*($P$9/100)),B15+$O$9)","v":3.657},{"$f":"IF($B15*($P$9/100)>$O$9,$B15-($B15*($P$9/100)),$B15-$O$9)","v":2.7030000000000003},{"$nulls":4},"X Mean ± SD:",null,{"$f":"B32","v":10.785499999999999},"±",{"$f":"B33","v":7.1061252118377274}]
[null,{"$f":"IF(B16*($P$9/100)>$O$9,B16+(B16*($P$9/100)),B16+$O$9)","v":23.011500000000002},{"$f":"IF($B16*($P$9/100)>$O$9,$B16-($B16*($P$9/100)),$B16-$O$9)","v":17.008500000000002},{"$nulls":4},"Y Mean ± SD:",null,{"$f":"C32","v":10.865},"±",{"$f":"C33","v":7.3082926942797739}]
[null,{"$f":"IF(B17*($P$9/100)>$O$9,B17+(B17*($P$9/100)),B17+$O$9)","v":3.9215},{"$f":"IF($B17*($P$9/100)>$O$9,$B17-($B17*($P$9/100)),$B17-$O$9)","v":2.8985000000000003},{"$nulls":4},"Std Dev Diffs:",null,{"$f":"SQRT(E34)","v":2.8017289294981258E-16}]
[null,{"$f":"IF(B18*($P$9/100)>$O$9,B18+(B18*($P$9/100)),B18+$O$9)","v":9.6024999999999991},{"$f":"IF($B18*($P$9/100)>$O$9,$B18-($B18*($P$9/100)),$B18-$O$9)","v":7.0975000000000001}]
[null,{"$f":"IF(B19*($P$9/100)>$O$9,B19+(B19*($P$9/100)),B19+$O$9)","v":3.8525},{"$f":"IF($B19*($P$9/100)>$O$9,$B19-($B19*($P$9/100)),$B19-$O$9)","v":2.8475000000000001}]
[null,{"$f":"IF(B20*($P$9/100)>$O$9,B20+(B20*($P$9/100)),B20+$O$9)","v":24.334},{"$f":"IF($B20*($P$9/100)>$O$9,$B20-($B20*($P$9/100)),$B20-$O$9)","v":17.986000000000001}]
[null,{"$f":"IF(B21*($P$9/100)>$O$9,B21+(B21*($P$9/100)),B21+$O$9)","v":24.4145},{"$f":"IF($B21*($P$9/100)>$O$9,$B21-($B21*($P$9/100)),$B21-$O$9)","v":18.045500000000001}]
[null,{"$f":"IF(B22*($P$9/100)>$O$9,B22+(B22*($P$9/100)),B22+$O$9)","v":2.875},{"$f":"IF($B22*($P$9/100)>$O$9,$B22-($B22*($P$9/100)),$B22-$O$9)","v":2.125}]
[null,{"$f":"IF(B23*($P$9/100)>$O$9,B23+(B23*($P$9/100)),B23+$O$9)","v":11.960000000000001},{"$f":"IF($B23*($P$9/100)>$O$9,$B23-($B23*($P$9/100)),$B23-$O$9)","v":8.8399999999999999}]
[null,{"$f":"IF(B24*($P$9/100)>$O$9,B24+(B24*($P$9/100)),B24+$O$9)","v":18.170000000000002},{"$f":"IF($B24*($P$9/100)>$O$9,$B24-($B24*($P$9/100)),$B24-$O$9)","v":13.43}]
[null,{"$f":"IF(B25*($P$9/100)>$O$9,B25+(B25*($P$9/100)),B25+$O$9)","v":21.274999999999999},{"$f":"IF($B25*($P$9/100)>$O$9,$B25-($B25*($P$9/100)),$B25-$O$9)","v":15.725}]
[null,{"$f":"IF(B26*($P$9/100)>$O$9,B26+(B26*($P$9/100)),B26+$O$9)","v":14.49},{"$f":"IF($B26*($P$9/100)>$O$9,$B26-($B26*($P$9/100)),$B26-$O$9)","v":10.709999999999999}]
[null,{"$f":"IF(B27*($P$9/100)>$O$9,B27+(B27*($P$9/100)),B27+$O$9)","v":9.4299999999999997},{"$f":"IF($B27*($P$9/100)>$O$9,$B27-($B27*($P$9/100)),$B27-$O$9)","v":6.9699999999999998}]
[null,{"$f":"IF(B28*($P$9/100)>$O$9,B28+(B28*($P$9/100)),B28+$O$9)","v":7.9350000000000005},{"$f":"IF($B28*($P$9/100)>$O$9,$B28-($B28*($P$9/100)),$B28-$O$9)","v":5.8650000000000002}]
[null,{"$f":"IF(B29*($P$9/100)>$O$9,B29+(B29*($P$9/100)),B29+$O$9)","v":5.8649999999999993},{"$f":"IF($B29*($P$9/100)>$O$9,$B29-($B29*($P$9/100)),$B29-$O$9)","v":4.335}]
[null,{"$f":"IF(B30*($P$9/100)>$O$9,B30+(B30*($P$9/100)),B30+$O$9)","v":5.2899999999999991},{"$f":"IF($B30*($P$9/100)>$O$9,$B30-($B30*($P$9/100)),$B30-$O$9)","v":3.9099999999999997}]
[null,{"$f":"IF(B31*($P$9/100)>$O$9,B31+(B31*($P$9/100)),B31+$O$9)","v":22.425000000000001},{"$f":"IF($B31*($P$9/100)>$O$9,$B31-($B31*($P$9/100)),$B31-$O$9)","v":16.574999999999999}]